EDA Update

Dataset statistics

Number of variables	16
Number of observations	840520
Missing cells	587717
Missing cells (%)	4.4%
Duplicate rows	4091
Duplicate rows (%)	0.5%
Total size in memory	645.8 MiB
Average record size in memory	805.7 B

Variable types

Numeric	7
Categorical	9

Alerts

Dataset has 4091 (0.5%) duplicate rows	Duplicates
`Fecha` has a high cardinality: 2341 distinct values	High cardinality
`Delito` has a high cardinality: 349 distinct values	High cardinality
`Colonia` has a high cardinality: 2009 distinct values	High cardinality
`Alcaldia` has a high cardinality: 459 distinct values	High cardinality
`idCarpeta` is highly overall correlated with `Año`	High correlation
`Dia` is highly overall correlated with `Mes`	High correlation
`Año` is highly overall correlated with `idCarpeta`	High correlation
`Mes` is highly overall correlated with `Dia`	High correlation
`CalidadJuridica` is highly overall correlated with `Categoria` and 1 other fields	High correlation
`TipoPersona` is highly overall correlated with `CalidadJuridica`	High correlation
`Categoria` is highly overall correlated with `CalidadJuridica`	High correlation
`longitud` is highly overall correlated with `latitud`	High correlation
`latitud` is highly overall correlated with `longitud`	High correlation
`Colonia` has 38296 (4.6%) missing values	Missing
`Sexo` has 161205 (19.2%) missing values	Missing
`Edad` has 302781 (36.0%) missing values	Missing
`longitud` has 38086 (4.5%) missing values	Missing
`latitud` has 38084 (4.5%) missing values	Missing
`idCarpeta` is highly skewed (γ1 = 24.97368042)	Skewed
`Hora` has 11988 (1.4%) zeros	Zeros

Reproduction

Analysis started	2022-11-28 20:03:46.124249
Analysis finished	2022-11-28 20:05:32.178642
Duration	1 minute and 46.05 seconds
Software version	pandas-profiling vv3.5.0
Download configuration	config.json

idCarpeta
Real number (ℝ)

HIGH CORRELATION
SKEWED

Distinct	785490
Distinct (%)	93.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8770736.1

Minimum	8118324
Maximum	84881009
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.8 MiB

Quantile statistics

Minimum	8118324
5-th percentile	8365696
Q1	8537366.8
median	8767879.5
Q3	9001345.5
95-th percentile	9182364.1
Maximum	84881009
Range	76762685
Interquartile range (IQR)	463978.75

Descriptive statistics

Standard deviation	275971.26
Coefficient of variation (CV)	0.031465005
Kurtosis	6881.4047
Mean	8770736.1
Median Absolute Deviation (MAD)	232084.5
Skewness	24.97368
Sum	7.3719791 × 10¹²
Variance	7.6160134 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9125284	26	< 0.1%
9057330	22	< 0.1%
8718889	19	< 0.1%
8929524	17	< 0.1%
9124498	16	< 0.1%
9075349	15	< 0.1%
8406552	15	< 0.1%
9059545	14	< 0.1%
9119601	13	< 0.1%
8808098	13	< 0.1%
Other values (785480)	840350	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8118324	1	< 0.1%
8236085	1	< 0.1%
8312585	1	< 0.1%
8322418	1	< 0.1%
8322419	1	< 0.1%
8322420	1	< 0.1%
8322421	1	< 0.1%
8322422	1	< 0.1%
8322425	1	< 0.1%
8322426	1	< 0.1%

Value	Count	Frequency (%)
84881009	1	< 0.1%
9226877	1	< 0.1%
9226876	1	< 0.1%
9226875	1	< 0.1%
9226874	1	< 0.1%
9226873	1	< 0.1%
9226872	1	< 0.1%
9226871	1	< 0.1%
9226870	1	< 0.1%
9226869	1	< 0.1%

Dia
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	343
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	6.0594494

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.4366242
Coefficient of variation (CV)	0.56715123
Kurtosis	-1.1797016
Mean	6.0594494
Median Absolute Deviation (MAD)	3
Skewness	0.18681118
Sum	5091010
Variance	11.810386
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3	87183	10.4%
1	80659	9.6%
2	80104	9.5%
5	79526	9.5%
4	75365	9.0%
6	74401	8.9%
8	62318	7.4%
10	61394	7.3%
9	60117	7.2%
11	60069	7.1%
Other values (2)	119041	14.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	80659	9.6%
2	80104	9.5%
3	87183	10.4%
4	75365	9.0%
5	79526	9.5%
6	74401	8.9%
7	59938	7.1%
8	62318	7.4%
9	60117	7.2%
10	61394	7.3%

Value	Count	Frequency (%)
12	59103	7.0%
11	60069	7.1%
10	61394	7.3%
9	60117	7.2%
8	62318	7.4%
7	59938	7.1%
6	74401	8.9%
5	79526	9.5%
4	75365	9.0%
3	87183	10.4%

Mes
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	343
Missing (%)	< 0.1%
Memory size	57.1 MiB

Marzo	87183
Enero	80659
Febrero	80104
Mayo	79526
Abril	75365
Other values (7)	437340

Length

Max length	10
Median length	9
Mean length	6.2414777
Min length	4

Characters and Unicode

Total characters	5243946
Distinct characters	27
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Agosto
2nd row	Diciembre
3rd row	Diciembre
4th row	Enero
5th row	Enero

Common Values

Value	Count	Frequency (%)
Marzo	87183	10.4%
Enero	80659	9.6%
Febrero	80104	9.5%
Mayo	79526	9.5%
Abril	75365	9.0%
Junio	74401	8.9%
Agosto	62318	7.4%
Octubre	61394	7.3%
Septiembre	60117	7.2%
Noviembre	60069	7.1%
Other values (2)	119041	14.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
marzo	87183	10.4%
enero	80659	9.6%
febrero	80104	9.5%
mayo	79526	9.5%
abril	75365	9.0%
junio	74401	8.9%
agosto	62318	7.4%
octubre	61394	7.3%
septiembre	60117	7.2%
noviembre	60069	7.1%
Other values (2)	119041	14.2%

Most occurring characters

Value	Count	Frequency (%)
e	720956	13.7%
o	646516	12.3%
r	644098	12.3%
i	448096	8.5%
b	396152	7.6%
u	195733	3.7%
t	183829	3.5%
m	179289	3.4%
M	166709	3.2%
a	166709	3.2%
Other values (17)	1495859	28.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4403769	84.0%
Uppercase Letter	840177	16.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	720956	16.4%
o	646516	14.7%
r	644098	14.6%
i	448096	10.2%
b	396152	9.0%
u	195733	4.4%
t	183829	4.2%
m	179289	4.1%
a	166709	3.8%
n	155060	3.5%
Other values (8)	667331	15.2%

Uppercase Letter

Value	Count	Frequency (%)
M	166709	19.8%
A	137683	16.4%
J	134339	16.0%
E	80659	9.6%
F	80104	9.5%
O	61394	7.3%
S	60117	7.2%
N	60069	7.1%
D	59103	7.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5243946	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	720956	13.7%
o	646516	12.3%
r	644098	12.3%
i	448096	8.5%
b	396152	7.6%
u	195733	3.7%
t	183829	3.5%
m	179289	3.4%
M	166709	3.2%
a	166709	3.2%
Other values (17)	1495859	28.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5243946	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	720956	13.7%
o	646516	12.3%
r	644098	12.3%
i	448096	8.5%
b	396152	7.6%
u	195733	3.7%
t	183829	3.5%
m	179289	3.4%
M	166709	3.2%
a	166709	3.2%
Other values (17)	1495859	28.5%

Año
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	343
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2020.1683

Minimum	2016
Maximum	2022
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.8 MiB

Quantile statistics

Minimum	2016
5-th percentile	2019
Q1	2019
median	2020
Q3	2021
95-th percentile	2022
Maximum	2022
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.1101757
Coefficient of variation (CV)	0.00054954615
Kurtosis	-0.6204538
Mean	2020.1683
Median Absolute Deviation (MAD)	1
Skewness	-0.0045060485
Sum	1.697299 × 10⁹
Variance	1.2324901
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2019	260515	31.0%
2021	233266	27.8%
2020	213883	25.4%
2022	110035	13.1%
2018	17631	2.1%
2017	3241	0.4%
2016	1606	0.2%
(Missing)	343	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2016	1606	0.2%
2017	3241	0.4%
2018	17631	2.1%
2019	260515	31.0%
2020	213883	25.4%
2021	233266	27.8%
2022	110035	13.1%

Value	Count	Frequency (%)
2022	110035	13.1%
2021	233266	27.8%
2020	213883	25.4%
2019	260515	31.0%
2018	17631	2.1%
2017	3241	0.4%
2016	1606	0.2%

Fecha
Categorical

Distinct	2341
Distinct (%)	0.3%
Missing	343
Missing (%)	< 0.1%
Memory size	60.1 MiB

01/01/2021	1199
01/01/2020	1114
01/04/2019	1030
15/03/2019	951
15/02/2019	948
Other values (2336)	834935

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	8401770
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	67 ?
Unique (%)	< 0.1%

Sample

1st row	29/08/2018
2nd row	15/12/2018
3rd row	22/12/2018
4th row	04/01/2019
5th row	03/01/2019

Common Values

Value	Count	Frequency (%)
01/01/2021	1199	0.1%
01/01/2020	1114	0.1%
01/04/2019	1030	0.1%
15/03/2019	951	0.1%
15/02/2019	948	0.1%
01/03/2019	941	0.1%
01/02/2019	934	0.1%
15/05/2019	925	0.1%
01/07/2019	921	0.1%
01/08/2019	914	0.1%
Other values (2331)	830300	98.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
01/01/2021	1199	0.1%
01/01/2020	1114	0.1%
01/04/2019	1030	0.1%
15/03/2019	951	0.1%
15/02/2019	948	0.1%
01/03/2019	941	0.1%
01/02/2019	934	0.1%
15/05/2019	925	0.1%
01/07/2019	921	0.1%
01/08/2019	914	0.1%
Other values (2331)	830300	98.8%

Most occurring characters

Value	Count	Frequency (%)
0	2110064	25.1%
2	1998298	23.8%
/	1680354	20.0%
1	1219272	14.5%
9	398476	4.7%
3	208312	2.5%
5	165844	2.0%
8	162041	1.9%
6	157262	1.9%
4	156942	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6721416	80.0%
Other Punctuation	1680354	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2110064	31.4%
2	1998298	29.7%
1	1219272	18.1%
9	398476	5.9%
3	208312	3.1%
5	165844	2.5%
8	162041	2.4%
6	157262	2.3%
4	156942	2.3%
7	144905	2.2%

Other Punctuation

Value	Count	Frequency (%)
/	1680354	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	8401770	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2110064	25.1%
2	1998298	23.8%
/	1680354	20.0%
1	1219272	14.5%
9	398476	4.7%
3	208312	2.5%
5	165844	2.0%
8	162041	1.9%
6	157262	1.9%
4	156942	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8401770	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2110064	25.1%
2	1998298	23.8%
/	1680354	20.0%
1	1219272	14.5%
9	398476	4.7%
3	208312	2.5%
5	165844	2.0%
8	162041	1.9%
6	157262	1.9%
4	156942	1.9%

Hora
Real number (ℝ)

Distinct	1688
Distinct (%)	0.2%
Missing	333
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	47470.789

Minimum	0
Maximum	86340
Zeros	11988
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	12.8 MiB

Quantile statistics

Minimum	0
5-th percentile	7200
Q1	35100
median	46800
Q3	64740
95-th percentile	79200
Maximum	86340
Range	86340
Interquartile range (IQR)	29640

Descriptive statistics

Standard deviation	21046.011
Coefficient of variation (CV)	0.44334656
Kurtosis	-0.52250632
Mean	47470.789
Median Absolute Deviation (MAD)	14400
Skewness	-0.28746314
Sum	3.9884339 × 10¹⁰
Variance	4.4293456 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
43200	72177	8.6%
36000	31856	3.8%
39600	19059	2.3%
54000	18934	2.3%
50400	18414	2.2%
32400	18406	2.2%
57600	17106	2.0%
64800	16101	1.9%
46800	15839	1.9%
61200	15833	1.9%
Other values (1678)	596462	71.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11988	1.4%
1	7	< 0.1%
2	7	< 0.1%
3	7	< 0.1%
4	6	< 0.1%
5	7	< 0.1%
6	6	< 0.1%
7	6	< 0.1%
8	4	< 0.1%
9	5	< 0.1%

Value	Count	Frequency (%)
86340	238	< 0.1%
86280	82	< 0.1%
86220	48	< 0.1%
86160	42	< 0.1%
86100	485	0.1%
86040	32	< 0.1%
85980	38	< 0.1%
85920	40	< 0.1%
85860	35	< 0.1%
85800	1102	0.1%

Delito
Categorical

Distinct	349
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.4 MiB

VIOLENCIA FAMILIAR	114006
FRAUDE	59069
AMENAZAS	55926
ROBO DE OBJETOS	41868
ROBO A TRANSEUNTE EN VIA PUBLICA CON VIOLENCIA	38160
Other values (344)	531491

Length

Max length	213
Median length	91
Mean length	30.211439
Min length	4

Characters and Unicode

Total characters	25393319
Distinct characters	47
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	20 ?
Unique (%)	< 0.1%

Sample

1st row	FRAUDE
2nd row	PRODUCCIÓN, IMPRESIÓN, ENAJENACIÓN, DISTRIBUCIÓN, ALTERACIÓN O FALSIFICACIÓN DE TÍTULOS AL PORTADOR, DOCUMENTOS DE CRÉDITO PÚBLICOS O VALES DE CANJE
3rd row	ROBO A TRANSEUNTE SALIENDO DEL BANCO CON VIOLENCIA
4th row	ROBO DE VEHICULO DE SERVICIO PARTICULAR SIN VIOLENCIA
5th row	ROBO DE MOTOCICLETA SIN VIOLENCIA

Common Values

Value	Count	Frequency (%)
VIOLENCIA FAMILIAR	114006	13.6%
FRAUDE	59069	7.0%
AMENAZAS	55926	6.7%
ROBO DE OBJETOS	41868	5.0%
ROBO A TRANSEUNTE EN VIA PUBLICA CON VIOLENCIA	38160	4.5%
ROBO A NEGOCIO SIN VIOLENCIA	29565	3.5%
ROBO DE ACCESORIOS DE AUTO	27498	3.3%
ROBO DE OBJETOS DEL INTERIOR DE UN VEHICULO	21302	2.5%
ROBO A NEGOCIO CON VIOLENCIA	20492	2.4%
ROBO DE VEHICULO DE SERVICIO PARTICULAR SIN VIOLENCIA	17196	2.0%
Other values (339)	415438	49.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de	438736	11.2%
violencia	331576	8.5%
robo	331502	8.5%
a	227978	5.8%
con	116526	3.0%
familiar	114006	2.9%
sin	106548	2.7%
en	99102	2.5%
por	84513	2.2%
negocio	71650	1.8%
Other values (481)	1981454	50.8%

Most occurring characters

Value	Count	Frequency (%)
	3063103	12.1%
O	2784411	11.0%
A	2453243	9.7%
I	2384482	9.4%
E	2283658	9.0%
N	1699843	6.7%
R	1369313	5.4%
C	1358867	5.4%
S	1112839	4.4%
L	1086493	4.3%
Other values (37)	5797067	22.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	22177904	87.3%
Space Separator	3063103	12.1%
Other Punctuation	88998	0.4%
Open Punctuation	21229	0.1%
Close Punctuation	21229	0.1%
Decimal Number	11472	< 0.1%
Math Symbol	8823	< 0.1%
Control	561	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	2784411	12.6%
A	2453243	11.1%
I	2384482	10.8%
E	2283658	10.3%
N	1699843	7.7%
R	1369313	6.2%
C	1358867	6.1%
S	1112839	5.0%
L	1086493	4.9%
D	1007277	4.5%
Other values (21)	4637478	20.9%

Decimal Number

Value	Count	Frequency (%)
0	5882	51.3%
9	2941	25.6%
3	1553	13.5%
1	952	8.3%
8	144	1.3%

Other Punctuation

Value	Count	Frequency (%)
,	75709	85.1%
/	12887	14.5%
.	402	0.5%

Math Symbol

Value	Count	Frequency (%)
<	2941	33.3%
+	2941	33.3%
>	2941	33.3%

Control

Value	Count	Frequency (%)
	392	69.9%
	169	30.1%

Space Separator

Value	Count	Frequency (%)
	3063103	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	21229	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	21229	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	22177904	87.3%
Common	3215415	12.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	2784411	12.6%
A	2453243	11.1%
I	2384482	10.8%
E	2283658	10.3%
N	1699843	7.7%
R	1369313	6.2%
C	1358867	6.1%
S	1112839	5.0%
L	1086493	4.9%
D	1007277	4.5%
Other values (21)	4637478	20.9%

Common

Value	Count	Frequency (%)
	3063103	95.3%
,	75709	2.4%
(	21229	0.7%
)	21229	0.7%
/	12887	0.4%
0	5882	0.2%
<	2941	0.1%
+	2941	0.1%
9	2941	0.1%
>	2941	0.1%
Other values (6)	3612	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25198588	99.2%
None	194731	0.8%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3063103	12.2%
O	2784411	11.0%
A	2453243	9.7%
I	2384482	9.5%
E	2283658	9.1%
N	1699843	6.7%
R	1369313	5.4%
C	1358867	5.4%
S	1112839	4.4%
L	1086493	4.3%
Other values (28)	5602336	22.2%

None

Value	Count	Frequency (%)
Ó	95220	48.9%
Ñ	35884	18.4%
Ú	22144	11.4%
Á	14780	7.6%
Í	11704	6.0%
É	10936	5.6%
Ã	3502	1.8%
	392	0.2%
	169	0.1%

CalidadJuridica
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	65.3 MiB

VICTIMA Y DENUNCIANTE	542855
OFENDIDO	132812
VICTIMA	96709
LESIONADO	24280
AGRAVIADO	18673
Other values (2)	25190

Length

Max length	22
Median length	21
Mean length	16.455263
Min length	7

Characters and Unicode

Total characters	13830961
Distinct characters	18
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	OFENDIDO
2nd row	VICTIMA Y DENUNCIANTE
3rd row	VICTIMA Y DENUNCIANTE
4th row	VICTIMA Y DENUNCIANTE
5th row	VICTIMA

Common Values

Value	Count	Frequency (%)
VICTIMA Y DENUNCIANTE	542855	64.6%
OFENDIDO	132812	15.8%
VICTIMA	96709	11.5%
LESIONADO	24280	2.9%
AGRAVIADO	18673	2.2%
CADAVER	16614	2.0%
OFENDIDO Y DENUNCIANTE	8576	1.0%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
victima	639564	32.9%
y	551431	28.4%
denunciante	551431	28.4%
ofendido	141388	7.3%
lesionado	24280	1.2%
agraviado	18673	1.0%
cadaver	16614	0.9%

Most occurring characters

Value	Count	Frequency (%)
I	2014900	14.6%
N	1819961	13.2%
A	1304522	9.4%
E	1285144	9.3%
C	1207609	8.7%
T	1190995	8.6%
	1102862	8.0%
D	893774	6.5%
V	674851	4.9%
M	639564	4.6%
Other values (8)	1696779	12.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	12728099	92.0%
Space Separator	1102862	8.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	2014900	15.8%
N	1819961	14.3%
A	1304522	10.2%
E	1285144	10.1%
C	1207609	9.5%
T	1190995	9.4%
D	893774	7.0%
V	674851	5.3%
M	639564	5.0%
Y	551431	4.3%
Other values (7)	1145348	9.0%

Space Separator

Value	Count	Frequency (%)
	1102862	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12728099	92.0%
Common	1102862	8.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	2014900	15.8%
N	1819961	14.3%
A	1304522	10.2%
E	1285144	10.1%
C	1207609	9.5%
T	1190995	9.4%
D	893774	7.0%
V	674851	5.3%
M	639564	5.0%
Y	551431	4.3%
Other values (7)	1145348	9.0%

Common

Value	Count	Frequency (%)
	1102862	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13830961	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	2014900	14.6%
N	1819961	13.2%
A	1304522	9.4%
E	1285144	9.3%
C	1207609	8.7%
T	1190995	8.6%
	1102862	8.0%
D	893774	6.5%
V	674851	4.9%
M	639564	4.6%
Other values (8)	1696779	12.3%

Categoria
Categorical

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	74.1 MiB

DELITO DE BAJO IMPACTO	683259
ROBO A TRANSEUNTE EN VÍA PÚBLICA CON Y SIN VIOLENCIA	44096
ROBO DE VEHÍCULO CON Y SIN VIOLENCIA	34601
ROBO A NEGOCIO CON VIOLENCIA	22591
HECHO NO DELICTIVO	13723
Other values (15)	42250

Length

Max length	61
Median length	22
Mean length	24.929235
Min length	9

Characters and Unicode

Total characters	20953521
Distinct characters	34
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DELITO DE BAJO IMPACTO
2nd row	DELITO DE BAJO IMPACTO
3rd row	ROBO A CUENTAHABIENTE SALIENDO DEL CAJERO CON VIOLENCIA
4th row	ROBO DE VEHÍCULO CON Y SIN VIOLENCIA
5th row	ROBO DE VEHÍCULO CON Y SIN VIOLENCIA

Common Values

Value	Count	Frequency (%)
DELITO DE BAJO IMPACTO	683259	81.3%
ROBO A TRANSEUNTE EN VÍA PÚBLICA CON Y SIN VIOLENCIA	44096	5.2%
ROBO DE VEHÍCULO CON Y SIN VIOLENCIA	34601	4.1%
ROBO A NEGOCIO CON VIOLENCIA	22591	2.7%
HECHO NO DELICTIVO	13723	1.6%
ROBO A REPARTIDOR CON Y SIN VIOLENCIA	10191	1.2%
VIOLACIÓN	6396	0.8%
ROBO A PASAJERO A BORDO DEL METRO CON Y SIN VIOLENCIA	5640	0.7%
HOMICIDIO DOLOSO	5388	0.6%
LESIONES DOLOSAS POR DISPARO DE ARMA DE FUEGO	4528	0.5%
Other values (10)	10107	1.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de	731566	19.0%
delito	683259	17.8%
bajo	683259	17.8%
impacto	683259	17.8%
con	126896	3.3%
robo	126896	3.3%
violencia	126896	3.3%
a	101467	2.6%
sin	99528	2.6%
y	99528	2.6%
Other values (37)	379862	9.9%

Most occurring characters

Value	Count	Frequency (%)
	3001896	14.3%
O	2791334	13.3%
I	1875548	9.0%
E	1816477	8.7%
A	1802226	8.6%
T	1493931	7.1%
D	1477064	7.0%
C	1089945	5.2%
L	933904	4.5%
B	871731	4.2%
Other values (24)	3799465	18.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	17942673	85.6%
Space Separator	3001896	14.3%
Decimal Number	3837	< 0.1%
Math Symbol	3597	< 0.1%
Control	1518	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	2791334	15.6%
I	1875548	10.5%
E	1816477	10.1%
A	1802226	10.0%
T	1493931	8.3%
D	1477064	8.2%
C	1089945	6.1%
L	933904	5.2%
B	871731	4.9%
P	757722	4.2%
Other values (16)	3032791	16.9%

Decimal Number

Value	Count	Frequency (%)
0	2398	62.5%
9	1199	31.2%
3	240	6.3%

Math Symbol

Value	Count	Frequency (%)
>	1199	33.3%
<	1199	33.3%
+	1199	33.3%

Space Separator

Value	Count	Frequency (%)
	3001896	100.0%

Control

Value	Count	Frequency (%)
	1518	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	17942673	85.6%
Common	3010848	14.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	2791334	15.6%
I	1875548	10.5%
E	1816477	10.1%
A	1802226	10.0%
T	1493931	8.3%
D	1477064	8.2%
C	1089945	6.1%
L	933904	5.2%
B	871731	4.9%
P	757722	4.2%
Other values (16)	3032791	16.9%

Common

Value	Count	Frequency (%)
	3001896	99.7%
0	2398	0.1%
	1518	0.1%
>	1199	< 0.1%
<	1199	< 0.1%
+	1199	< 0.1%
9	1199	< 0.1%
3	240	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20817951	99.4%
None	135570	0.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3001896	14.4%
O	2791334	13.4%
I	1875548	9.0%
E	1816477	8.7%
A	1802226	8.7%
T	1493931	7.2%
D	1477064	7.1%
C	1089945	5.2%
L	933904	4.5%
B	871731	4.2%
Other values (19)	3663895	17.6%

None

Value	Count	Frequency (%)
Í	78697	58.0%
Ú	44096	32.5%
Ó	8542	6.3%
Ã	2717	2.0%
	1518	1.1%

Colonia
Categorical

HIGH CARDINALITY
MISSING

Distinct	2009
Distinct (%)	0.3%
Missing	38296
Missing (%)	4.6%
Memory size	68.3 MiB

CENTRO	23294
DOCTORES	14307
DEL VALLE CENTRO	10261
ROMA NORTE	8594
MORELOS	7944
Other values (2004)	737824

Length

Max length	64
Median length	48
Mean length	15.986997
Min length	3

Characters and Unicode

Total characters	12825153
Distinct characters	75
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	38 ?
Unique (%)	< 0.1%

Sample

1st row	GUADALUPE INN
2nd row	VICTORIA DE LAS DEMOCRACIAS
3rd row	COPILCO UNIVERSIDAD ISSSTE
4th row	AGRÍCOLA PANTITLAN
5th row	PROGRESISTA

Common Values

Value	Count	Frequency (%)
CENTRO	23294	2.8%
DOCTORES	14307	1.7%
DEL VALLE CENTRO	10261	1.2%
ROMA NORTE	8594	1.0%
MORELOS	7944	0.9%
BUENAVISTA	7468	0.9%
NARVARTE	7287	0.9%
AGRÍCOLA ORIENTAL	6864	0.8%
POLANCO	6011	0.7%
JUÁREZ	6003	0.7%
Other values (1999)	704191	83.8%
(Missing)	38296	4.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de	120803	6.1%
san	115981	5.9%
santa	56115	2.8%
centro	42950	2.2%
sección	38794	2.0%
la	37631	1.9%
del	34199	1.7%
lomas	24246	1.2%
el	23744	1.2%
los	20008	1.0%
Other values (1482)	1461001	74.0%

Most occurring characters

Value	Count	Frequency (%)
A	1751352	13.7%
	1173541	9.2%
E	1105412	8.6%
O	925676	7.2%
N	864683	6.7%
L	799489	6.2%
R	794380	6.2%
S	680468	5.3%
C	673732	5.3%
I	667978	5.2%
Other values (65)	3388442	26.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	11514381	89.8%
Space Separator	1173541	9.2%
Decimal Number	71817	0.6%
Lowercase Letter	14136	0.1%
Other Punctuation	13784	0.1%
Math Symbol	12147	0.1%
Dash Punctuation	8211	0.1%
Open Punctuation	7365	0.1%
Close Punctuation	7155	0.1%
Control	2448	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1751352	15.2%
E	1105412	9.6%
O	925676	8.0%
N	864683	7.5%
L	799489	6.9%
R	794380	6.9%
S	680468	5.9%
C	673732	5.9%
I	667978	5.8%
T	605965	5.3%
Other values (24)	2645246	23.0%

Lowercase Letter

Value	Count	Frequency (%)
a	1828	12.9%
o	1704	12.1%
i	1626	11.5%
l	1140	8.1%
e	1128	8.0%
s	988	7.0%
t	944	6.7%
u	878	6.2%
n	864	6.1%
c	796	5.6%
Other values (8)	2240	15.8%

Decimal Number

Value	Count	Frequency (%)
2	19200	26.7%
1	15987	22.3%
0	11396	15.9%
3	9023	12.6%
9	5639	7.9%
4	2835	3.9%
7	2692	3.7%
8	2675	3.7%
5	1899	2.6%
6	471	0.7%

Other Punctuation

Value	Count	Frequency (%)
.	13274	96.3%
/	269	2.0%
?	241	1.7%

Math Symbol

Value	Count	Frequency (%)
>	4049	33.3%
+	4049	33.3%
<	4049	33.3%

Control

Value	Count	Frequency (%)
	1494	61.0%
	954	39.0%

Space Separator

Value	Count	Frequency (%)
	1173541	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	8211	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	7365	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	7155	100.0%

Other Symbol

Value	Count	Frequency (%)
°	168	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11528517	89.9%
Common	1296636	10.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1751352	15.2%
E	1105412	9.6%
O	925676	8.0%
N	864683	7.5%
L	799489	6.9%
R	794380	6.9%
S	680468	5.9%
C	673732	5.8%
I	667978	5.8%
T	605965	5.3%
Other values (42)	2659382	23.1%

Common

Value	Count	Frequency (%)
	1173541	90.5%
2	19200	1.5%
1	15987	1.2%
.	13274	1.0%
0	11396	0.9%
3	9023	0.7%
-	8211	0.6%
(	7365	0.6%
)	7155	0.6%
9	5639	0.4%
Other values (13)	25845	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12569355	98.0%
None	255798	2.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1751352	13.9%
	1173541	9.3%
E	1105412	8.8%
O	925676	7.4%
N	864683	6.9%
L	799489	6.4%
R	794380	6.3%
S	680468	5.4%
C	673732	5.4%
I	667978	5.3%
Other values (52)	3132644	24.9%

None

Value	Count	Frequency (%)
Ó	103456	40.4%
Á	54556	21.3%
É	37166	14.5%
Í	35216	13.8%
Ñ	9918	3.9%
Ã	6457	2.5%
Ú	6203	2.4%
	1494	0.6%
	954	0.4%
Ü	190	0.1%
Other values (3)	188	0.1%

Alcaldia
Categorical

Distinct	459
Distinct (%)	0.1%
Missing	1445
Missing (%)	0.2%
Memory size	61.7 MiB

IZTAPALAPA	128413
CUAUHTEMOC	121721
GUSTAVO A MADERO	86656
BENITO JUAREZ	62366
ALVARO OBREGON	60058
Other values (454)	379861

Length

Max length	38
Median length	35
Mean length	11.991984
Min length	4

Characters and Unicode

Total characters	10062174
Distinct characters	32
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	195 ?
Unique (%)	< 0.1%

Sample

1st row	ALVARO OBREGON
2nd row	AZCAPOTZALCO
3rd row	COYOACAN
4th row	IZTACALCO
5th row	IZTAPALAPA

Common Values

Value	Count	Frequency (%)
IZTAPALAPA	128413	15.3%
CUAUHTEMOC	121721	14.5%
GUSTAVO A MADERO	86656	10.3%
BENITO JUAREZ	62366	7.4%
ALVARO OBREGON	60058	7.1%
COYOACAN	55522	6.6%
MIGUEL HIDALGO	52333	6.2%
TLALPAN	50498	6.0%
VENUSTIANO CARRANZA	48519	5.8%
AZCAPOTZALCO	40477	4.8%
Other values (449)	132512	15.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
iztapalapa	128413	9.8%
cuauhtemoc	121721	9.3%
madero	86662	6.6%
gustavo	86656	6.6%
a	86656	6.6%
juarez	63107	4.8%
benito	62366	4.8%
obregon	60060	4.6%
alvaro	60058	4.6%
coyoacan	55522	4.2%
Other values (532)	498095	38.0%

Most occurring characters

Value	Count	Frequency (%)
A	1937987	19.3%
O	971171	9.7%
C	671964	6.7%
T	628805	6.2%
L	606450	6.0%
E	564150	5.6%
U	536563	5.3%
	470246	4.7%
I	458959	4.6%
R	414324	4.1%
Other values (22)	2801555	27.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	9591901	95.3%
Space Separator	470246	4.7%
Lowercase Letter	16	< 0.1%
Other Punctuation	7	< 0.1%
Dash Punctuation	2	< 0.1%
Decimal Number	2	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1937987	20.2%
O	971171	10.1%
C	671964	7.0%
T	628805	6.6%
L	606450	6.3%
E	564150	5.9%
U	536563	5.6%
I	458959	4.8%
R	414324	4.3%
N	412192	4.3%
Other values (15)	2389336	24.9%

Lowercase Letter

Value	Count	Frequency (%)
u	8	50.0%
l	4	25.0%
m	4	25.0%

Space Separator

Value	Count	Frequency (%)
	470246	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	7	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2	100.0%

Decimal Number

Value	Count	Frequency (%)
2	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9591917	95.3%
Common	470257	4.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1937987	20.2%
O	971171	10.1%
C	671964	7.0%
T	628805	6.6%
L	606450	6.3%
E	564150	5.9%
U	536563	5.6%
I	458959	4.8%
R	414324	4.3%
N	412192	4.3%
Other values (18)	2389352	24.9%

Common

Value	Count	Frequency (%)
	470246	> 99.9%
.	7	< 0.1%
-	2	< 0.1%
2	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10062168	> 99.9%
None	6	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1937987	19.3%
O	971171	9.7%
C	671964	6.7%
T	628805	6.2%
L	606450	6.0%
E	564150	5.6%
U	536563	5.3%
	470246	4.7%
I	458959	4.6%
R	414324	4.1%
Other values (21)	2801549	27.8%

None

Value	Count	Frequency (%)
Ñ	6	100.0%

Sexo
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	161205
Missing (%)	19.2%
Memory size	53.8 MiB

Masculino	361936
Femenino	317379

Length

Max length	9
Median length	9
Mean length	8.5327955
Min length	8

Characters and Unicode

Total characters	5796456
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Masculino
2nd row	Femenino
3rd row	Masculino
4th row	Masculino
5th row	Masculino

Common Values

Value	Count	Frequency (%)
Masculino	361936	43.1%
Femenino	317379	37.8%
(Missing)	161205	19.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
masculino	361936	53.3%
femenino	317379	46.7%

Most occurring characters

Value	Count	Frequency (%)
n	996694	17.2%
i	679315	11.7%
o	679315	11.7%
e	634758	11.0%
M	361936	6.2%
a	361936	6.2%
s	361936	6.2%
c	361936	6.2%
u	361936	6.2%
l	361936	6.2%
Other values (2)	634758	11.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5117141	88.3%
Uppercase Letter	679315	11.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	996694	19.5%
i	679315	13.3%
o	679315	13.3%
e	634758	12.4%
a	361936	7.1%
s	361936	7.1%
c	361936	7.1%
u	361936	7.1%
l	361936	7.1%
m	317379	6.2%

Uppercase Letter

Value	Count	Frequency (%)
M	361936	53.3%
F	317379	46.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5796456	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	996694	17.2%
i	679315	11.7%
o	679315	11.7%
e	634758	11.0%
M	361936	6.2%
a	361936	6.2%
s	361936	6.2%
c	361936	6.2%
u	361936	6.2%
l	361936	6.2%
Other values (2)	634758	11.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5796456	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	996694	17.2%
i	679315	11.7%
o	679315	11.7%
e	634758	11.0%
M	361936	6.2%
a	361936	6.2%
s	361936	6.2%
c	361936	6.2%
u	361936	6.2%
l	361936	6.2%
Other values (2)	634758	11.0%

Edad
Real number (ℝ)

Distinct	112
Distinct (%)	< 0.1%
Missing	302781
Missing (%)	36.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.840404

Minimum	0
Maximum	369
Zeros	1873
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	12.8 MiB

Quantile statistics

Minimum	0
5-th percentile	15
Q1	27
median	37
Q3	49
95-th percentile	68
Maximum	369
Range	369
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	16.271485
Coefficient of variation (CV)	0.41893193
Kurtosis	0.3442314
Mean	38.840404
Median Absolute Deviation (MAD)	11
Skewness	0.38892028
Sum	20886000
Variance	264.76124
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	14712	1.8%
28	14484	1.7%
29	14132	1.7%
27	14039	1.7%
31	13913	1.7%
32	13869	1.7%
35	13816	1.6%
26	13708	1.6%
33	13676	1.6%
34	13400	1.6%
Other values (102)	397990	47.4%
(Missing)	302781	36.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1873	0.2%
1	820	0.1%
2	1036	0.1%
3	1477	0.2%
4	1601	0.2%
5	1604	0.2%
6	1595	0.2%
7	1539	0.2%
8	1582	0.2%
9	1557	0.2%

Value	Count	Frequency (%)
369	1	< 0.1%
258	1	< 0.1%
120	1	< 0.1%
114	1	< 0.1%
111	1	< 0.1%
110	1	< 0.1%
107	1	< 0.1%
104	2	< 0.1%
103	2	< 0.1%
102	2	< 0.1%

TipoPersona
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	6114
Missing (%)	0.7%
Memory size	56.6 MiB

FISICA	659630
MORAL	174776

Length

Max length	6
Median length	6
Mean length	5.7905384
Min length	5

Characters and Unicode

Total characters	4831660
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FISICA
2nd row	FISICA
3rd row	FISICA
4th row	FISICA
5th row	FISICA

Common Values

Value	Count	Frequency (%)
FISICA	659630	78.5%
MORAL	174776	20.8%
(Missing)	6114	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
fisica	659630	79.1%
moral	174776	20.9%

Most occurring characters

Value	Count	Frequency (%)
I	1319260	27.3%
A	834406	17.3%
F	659630	13.7%
S	659630	13.7%
C	659630	13.7%
M	174776	3.6%
O	174776	3.6%
R	174776	3.6%
L	174776	3.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4831660	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	1319260	27.3%
A	834406	17.3%
F	659630	13.7%
S	659630	13.7%
C	659630	13.7%
M	174776	3.6%
O	174776	3.6%
R	174776	3.6%
L	174776	3.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4831660	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	1319260	27.3%
A	834406	17.3%
F	659630	13.7%
S	659630	13.7%
C	659630	13.7%
M	174776	3.6%
O	174776	3.6%
R	174776	3.6%
L	174776	3.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4831660	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	1319260	27.3%
A	834406	17.3%
F	659630	13.7%
S	659630	13.7%
C	659630	13.7%
M	174776	3.6%
O	174776	3.6%
R	174776	3.6%
L	174776	3.6%

longitud
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct	537438
Distinct (%)	67.0%
Missing	38086
Missing (%)	4.5%
Infinite	0
Infinite (%)	0.0%
Mean	-99.136243

Minimum	-99.342357
Maximum	-98.946858
Zeros	0
Zeros (%)	0.0%
Negative	802434
Negative (%)	95.5%
Memory size	12.8 MiB

Quantile statistics

Minimum	-99.342357
5-th percentile	-99.236638
Q1	-99.17634
median	-99.140802
Q3	-99.096198
95-th percentile	-99.024952
Maximum	-98.946858
Range	0.39549952
Interquartile range (IQR)	0.080142204

Descriptive statistics

Standard deviation	0.06199455
Coefficient of variation (CV)	-0.00062534697
Kurtosis	-0.0085473273
Mean	-99.136243
Median Absolute Deviation (MAD)	0.03992569
Skewness	0.092767595
Sum	-79550292
Variance	0.0038433242
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-99.14957	255	< 0.1%
-99.14838	179	< 0.1%
-99.1446389	160	< 0.1%
-99.0905297	143	< 0.1%
-99.14792	140	< 0.1%
-99.14717	119	< 0.1%
-99.14133	113	< 0.1%
-99.15316	109	< 0.1%
-99.14544	90	< 0.1%
-99.14512	90	< 0.1%
Other values (537428)	801036	95.3%
(Missing)	38086	4.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-99.34235742	1	< 0.1%
-99.34146881	1	< 0.1%
-99.34145294	1	< 0.1%
-99.34135616	1	< 0.1%
-99.3413415	1	< 0.1%
-99.34125517	1	< 0.1%
-99.34121132	1	< 0.1%
-99.34072	1	< 0.1%
-99.3405354	2	< 0.1%
-99.34024	1	< 0.1%

Value	Count	Frequency (%)
-98.94685791	1	< 0.1%
-98.94737408	1	< 0.1%
-98.94771605	1	< 0.1%
-98.94780786	1	< 0.1%
-98.94808643	5	< 0.1%
-98.94813	2	< 0.1%
-98.94817114	1	< 0.1%
-98.94832	1	< 0.1%
-98.9483875	1	< 0.1%
-98.94854777	1	< 0.1%

latitud
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct	540191
Distinct (%)	67.3%
Missing	38084
Missing (%)	4.5%
Infinite	0
Infinite (%)	0.0%
Mean	19.385183

Minimum	19.126361
Maximum	19.583333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.8 MiB

Quantile statistics

Minimum	19.126361
5-th percentile	19.26385
Q1	19.3352
median	19.386776
Q3	19.438167
95-th percentile	19.494466
Maximum	19.583333
Range	0.45697268
Interquartile range (IQR)	0.10296697

Descriptive statistics

Standard deviation	0.071926275
Coefficient of variation (CV)	0.0037103739
Kurtosis	-0.26534464
Mean	19.385183
Median Absolute Deviation (MAD)	0.051463613
Skewness	-0.20552355
Sum	15555369
Variance	0.0051733891
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.42121	260	< 0.1%
19.41792	168	< 0.1%
19.4183695	160	< 0.1%
19.42384	152	< 0.1%
19.3739788	143	< 0.1%
19.43403	123	< 0.1%
19.42449	106	< 0.1%
19.36174	98	< 0.1%
19.44631	95	< 0.1%
19.40188	90	< 0.1%
Other values (540181)	801041	95.3%
(Missing)	38084	4.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19.12636062	1	< 0.1%
19.12664586	1	< 0.1%
19.12703559	2	< 0.1%
19.12723891	1	< 0.1%
19.12733	1	< 0.1%
19.12755982	1	< 0.1%
19.12778569	1	< 0.1%
19.12781795	1	< 0.1%
19.1278348	1	< 0.1%
19.12796004	1	< 0.1%

Value	Count	Frequency (%)
19.5833333	1	< 0.1%
19.58232	1	< 0.1%
19.58111	1	< 0.1%
19.5806	1	< 0.1%
19.57955	2	< 0.1%
19.5792784	1	< 0.1%
19.57926981	1	< 0.1%
19.57888	1	< 0.1%
19.57887705	1	< 0.1%
19.57882592	1	< 0.1%

Auto

The auto setting is an interpretable pairwise column metric of the following mapping:

Variable_type-Variable_type : Method, Range
Categorical-Categorical : Cramer's V, [0,1]
Numerical-Categorical : Cramer's V, [0,1] (using a discretized numerical column)
Numerical-Numerical : Spearman's ρ, [-1,1]

The number of bins used in the discretization for the Numerical-Categorical column pair can be changed using config.correlations["auto"].n_bins. The number of bins affects the granularity of the association you wish to measure.

This configuration uses the recommended metric for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	idCarpeta	Dia	Mes	Año	Fecha	Hora	Delito	CalidadJuridica	Categoria	Colonia	Alcaldia	Sexo	Edad	TipoPersona	longitud	latitud
0	8324429.0	08	Agosto	2018.0	29/08/2018	43200.0	FRAUDE	OFENDIDO	DELITO DE BAJO IMPACTO	GUADALUPE INN	ALVARO OBREGON	Masculino	62.0	FISICA	-99.18314	19.36125
1	8324430.0	12	Diciembre	2018.0	15/12/2018	54000.0	PRODUCCIÓN, IMPRESIÓN, ENAJENACIÓN, DISTRIBUCIÓN, ALTERACIÓN O FALSIFICACIÓN DE TÍTULOS AL PORTADOR, DOCUMENTOS DE CRÉDITO PÚBLICOS O VALES DE CANJE	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	VICTORIA DE LAS DEMOCRACIAS	AZCAPOTZALCO	Femenino	38.0	FISICA	-99.16458	19.47181
2	8324431.0	12	Diciembre	2018.0	22/12/2018	55800.0	ROBO A TRANSEUNTE SALIENDO DEL BANCO CON VIOLENCIA	VICTIMA Y DENUNCIANTE	ROBO A CUENTAHABIENTE SALIENDO DEL CAJERO CON VIOLENCIA	COPILCO UNIVERSIDAD ISSSTE	COYOACAN	Masculino	42.0	FISICA	-99.18611	19.33797
3	8324435.0	01	Enero	2019.0	04/01/2019	21600.0	ROBO DE VEHICULO DE SERVICIO PARTICULAR SIN VIOLENCIA	VICTIMA Y DENUNCIANTE	ROBO DE VEHÍCULO CON Y SIN VIOLENCIA	AGRÍCOLA PANTITLAN	IZTACALCO	Masculino	35.0	FISICA	-99.05983	19.40327
4	8324438.0	01	Enero	2019.0	03/01/2019	72000.0	ROBO DE MOTOCICLETA SIN VIOLENCIA	VICTIMA	ROBO DE VEHÍCULO CON Y SIN VIOLENCIA	PROGRESISTA	IZTAPALAPA	Masculino	NaN	FISICA	-99.06324	19.35480
5	8324442.0	10	Octubre	2018.0	12/10/2018	64800.0	PRODUCCIÓN, IMPRESIÓN, ENAJENACIÓN, DISTRIBUCIÓN, ALTERACIÓN O FALSIFICACIÓN DE TÍTULOS AL PORTADOR, DOCUMENTOS DE CRÉDITO PÚBLICOS O VALES DE CANJE	OFENDIDO	DELITO DE BAJO IMPACTO	PUEBLO DE LOS REYES	COYOACAN	Femenino	42.0	FISICA	-99.16016	19.33537
6	8324444.0	01	Enero	2019.0	04/01/2019	30600.0	ROBO A TRANSEUNTE DE CELULAR SIN VIOLENCIA	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	TOLTECA	ALVARO OBREGON	Femenino	55.0	FISICA	-99.19472	19.39000
8	8324454.0	12	Diciembre	2018.0	27/12/2018	46800.0	PRODUCCIÓN, IMPRESIÓN, ENAJENACIÓN, DISTRIBUCIÓN, ALTERACIÓN O FALSIFICACIÓN DE TÍTULOS AL PORTADOR, DOCUMENTOS DE CRÉDITO PÚBLICOS O VALES DE CANJE	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	BANJIDAL	IZTAPALAPA	Femenino	83.0	FISICA	-99.13696	19.35996
9	8324455.0	01	Enero	2018.0	04/01/2018	46800.0	OMISION DE AUXILIO O DE CUIDADO	VICTIMA	DELITO DE BAJO IMPACTO	NaN	VENUSTIANO CARRANZA	Masculino	15.0	FISICA	NaN	NaN
10	8324457.0	05	Mayo	2018.0	11/05/2018	36000.0	DESPOJO	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	SANTIAGO ACAHUALTEPEC	IZTAPALAPA	Masculino	45.0	FISICA	-99.00410	19.35325

	idCarpeta	Dia	Mes	Año	Fecha	Hora	Delito	CalidadJuridica	Categoria	Colonia	Alcaldia	Sexo	Edad	TipoPersona	longitud	latitud
845612	9226860.0	06	Junio	2022.0	30/06/2022	36000.0	FRAUDE	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	BUENAVISTA	CUAUHTEMOC	Femenino	NaN	FISICA	-99.151585	19.440587
845613	9226868.0	06	Junio	2022.0	30/06/2022	64800.0	VIOLENCIA FAMILIAR	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	AMPLIACIÃ<U+0093>N PENITENCIARIA	VENUSTIANO CARRANZA	Femenino	61.0	FISICA	-99.116411	19.435591
845614	9226856.0	06	Junio	2022.0	30/06/2022	19200.0	ROBO DE OBJETOS DEL INTERIOR DE UN VEHICULO	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	OBSERVATORIO	MIGUEL HIDALGO	Masculino	62.0	FISICA	-99.189496	19.407119
845615	9226864.0	06	Junio	2022.0	30/06/2022	48600.0	AMENAZAS	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	AMPLIACIÃ<U+0093>N PANAMERICANA	GUSTAVO A MADERO	Masculino	48.0	FISICA	-99.144806	19.478034
845617	9226869.0	05	Mayo	2022.0	26/05/2022	23400.0	FRAUDE	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	VALLEJO	GUSTAVO A MADERO	Femenino	48.0	FISICA	-99.138365	19.466620
845618	9226872.0	06	Junio	2022.0	30/06/2022	70200.0	AMENAZAS	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	ZONA CENTRO	VENUSTIANO CARRANZA	Femenino	31.0	FISICA	-99.122936	19.436282
845619	9226875.0	06	Junio	2022.0	30/06/2022	57600.0	VIOLENCIA FAMILIAR	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	AMPLIACIÃ<U+0093>N ALPES	ALVARO OBREGON	Masculino	32.0	FISICA	-99.211916	19.357075
845620	9226873.0	06	Junio	2022.0	28/06/2022	9720.0	USURPACIÃ<U+0093>N DE IDENTIDAD	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	TEPETONGO	CUAJIMALPA DE MORELOS	Femenino	18.0	FISICA	-99.291582	19.370314
845621	9226876.0	06	Junio	2022.0	30/06/2022	75600.0	AMENAZAS	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	ANAHUAC	MIGUEL HIDALGO	Masculino	32.0	FISICA	-99.173565	19.440914
845622	9226874.0	06	Junio	2022.0	29/06/2022	21180.0	ROBO DE PLACA DE AUTOMOVIL	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	DOCTORES	CUAUHTEMOC	Femenino	44.0	FISICA	-99.146263	19.423728

Most frequently occurring

	idCarpeta	Dia	Mes	Año	Fecha	Hora	Delito	CalidadJuridica	Categoria	Colonia	Alcaldia	Sexo	Edad	TipoPersona	longitud	latitud	# duplicates
3016	9057330.0	07	Julio	2019.0	01/07/2019	0.0	FRAUDE	OFENDIDO	DELITO DE BAJO IMPACTO	NaN	CUAUHTEMOC	NaN	NaN	MORAL	NaN	NaN	22
1381	8808098.0	11	Noviembre	2020.0	24/11/2020	46800.0	AMENAZAS	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	CENTRO	CUAUHTEMOC	Femenino	NaN	FISICA	-99.136665	19.435871	12
1763	8866253.0	03	Marzo	2021.0	01/03/2021	54600.0	DISCRIMINACION	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	DOCTORES	CUAUHTEMOC	Femenino	NaN	FISICA	-99.151295	19.424873	12
2130	8929524.0	05	Mayo	2021.0	16/05/2021	36000.0	AMENAZAS	VICTIMA	DELITO DE BAJO IMPACTO	EL MIRADOR (NATIVITAS)	XOCHIMILCO	Femenino	NaN	FISICA	-99.096985	19.233895	11
3803	9187826.0	05	Mayo	2022.0	09/05/2022	40500.0	TORTURA	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	NaN	CUAUHTEMOC	Masculino	NaN	FISICA	NaN	NaN	11
3900	9202775.0	05	Mayo	2022.0	24/05/2022	49200.0	FRAUDE	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	NaN	CUAUHTEMOC	Masculino	NaN	FISICA	NaN	NaN	11
2444	8969356.0	07	Julio	2021.0	09/07/2021	53400.0	MALTRATO ANIMAL	VICTIMA	DELITO DE BAJO IMPACTO	SAN ANDRÉS	AZCAPOTZALCO	NaN	NaN	MORAL	-99.183025	19.494731	10
317	8644866.0	02	Febrero	2020.0	13/02/2020	32400.0	LA ADMINISTRACION DE JUSTICIA	VICTIMA	DELITO DE BAJO IMPACTO	XOCO	BENITO JUAREZ	Masculino	NaN	FISICA	-99.163043	19.364647	9
2637	8997917.0	07	Julio	2021.0	12/07/2021	32400.0	DESPOJO	VICTIMA	DELITO DE BAJO IMPACTO	NATIVITAS	XOCHIMILCO	Masculino	NaN	FISICA	-99.011235	19.249472	9
3422	9124498.0	02	Febrero	2022.0	16/02/2022	37260.0	EJERCICIO ILEGAL Y ABANDONO DEL SERVICIO PUBLICO	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	NaN	CUAUHTEMOC	Masculino	NaN	FISICA	NaN	NaN	9

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Other Punctuation

Math Symbol

Control

Space Separator

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Math Symbol

Space Separator

Control

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block